Format options specifies for file type.
TXT, CSV
Define Field Delimiter, Record Delimiter and Text Qualifier for file. Record delimiter indicates how the file recognizes as new record (row).
XML
Define tag to identify table row.
Consider tag's attributes as table's field
For example:
<row age="17">
<id>1</id>
<name>sze</name>
</row>
With this option is on, Navicat will recognizes "age" as a table field together with "id" and "name", otherwise, only "id" and "name" will be imported as table fields.
Note: Navicat does not support multiple level of XML file.
Excel
Select the worksheet(s) you wish to import from the excel source file. Each worksheet will be imported as a separate table.